package com.hkw.dao;

import com.hkw.model.Student;
import com.hkw.utils.PagesUtils;

import java.sql.SQLException;
import java.util.List;
/**
 *  Student类的dao接口，对外暴露接口方法
 */
public interface IStudentDao {
     //查询所有学生
     List<Student> findAll(PagesUtils pagesUtils) throws SQLException;
     //查询学生个数
     int  findAllRows() throws SQLException;
     //添加学生
     int insertStudent(Student student) throws SQLException;
     //根据id删除学生
     int deleteStudentById(int id) throws SQLException;
     //寻找学生根据id
     Student findStudentById(int id) throws SQLException;
     //更新学生信息
     int updateStudent(Student student) throws SQLException;
     //根据学生名和邮箱寻找学生
     Student findStudentByNameAndEmail(String name,String email) throws SQLException;
}
